{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["StartHere","5.ID","Financial information ","SI and regression Pt 1","Current operations Pt2 & Pt3 ","Franchise operations Pt2 & Pt3","Expected Values Pt3","Sheet9"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"StartHere","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,2,10,2],[11,2,12,2]]}
[]
[null,"Student Identification Sheet (version5.2)"]
[]
[null,"Name","Melissa Salgado"," <<- enter your name here",null,null,"(1)","Add your name to Cell C4 and your Student ID to cell C6. Then  Click [Start Here] to finish loading data."]
[null,null,null,null,null,null,"(2)","Change the file name to include your name. "]
[null,"Student ID","002 43 4822"," <<- enter your Student ID here",null,null,"(3)","When done with your work, Click [I'm Done]"]
[null,null,null,null,null,null,"(3)","Upload the file to the applicable iCollege"]
[null,"Date/time",{"$f":"NOW()","v":"2021-04-03T07:08:19.850"},null,null,null,null," assignment folder to receive credit for this workshop/tutorial"]
[null,null,"Spring 2021",null,null,null,"(4)","Never use a file created or started by another student (that is academic dishonesty).\nAll text, codes, writing, data entry, formulas, configuration and instructions must be performed by the individual submitting the work."]
[null,null,"You must use Excel Desktop. Cloud Excel 365 will not work for this class.",null,"2021-04-01T14:33:03.940","Melissa Salgado started S01"]
[]
[null,null,"Collaboration Started"]
[]
[null,null,"Individual Challenge started"]
[null,null,"Kurt Schmitz © 2020 Do not post or reproduce."]
[]
[null,"Excel release",{"$f":"INFO(\"release\")","v":"16.0"},"<< Mac Users below 16.24, please update!"]
[null,"OS",{"$f":"INFO(\"OSVERSION\")","v":"Windows (32-bit) NT 10.00"},"<< Windows users with version 16.0 are good to go."]

{"sheet":"5.ID","index":1,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Do Not Alter or Delete this Worksheet or you submission cannot be graded!",null,null,null,"DirVer"]
["Action","Name","Panther ID","Date/Time","S01"]
["Start S01","Melissa Salgado","002 43 4822","2021-04-01T14:33:03.680","michael mutinda"]
["Starter Sheet","None",0,"2020-01-01","C:\\Users\\micha\\AppData\\Local\\Temp"]
[null,null,null,null,"Welcome to Microsoft Excel version 16.0 build 13801 running on Windows (32-bit) NT 10.00!"]

{"sheet":"Financial information ","index":2,"n_rows":68,"n_cols":32,"rows_kept":68,"cut":false,"hidden":false,"merged":[[9,16,9,18],[40,1,40,2],[9,5,9,7],[9,9,9,11],[9,13,9,15]]}
["Donut Information ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]
["Based on the below data, create the profit model for Donuts to Go.",null,null,null,null,"Enter totals ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Melissa Salgado"]
["Assume that each customer will buy one donut and one cup of coffee",null,null,null,"Fixed Costs",{"$f":"SUM(C13:C28)","v":7050.35}]
[" ",null,null,null,"Varible Costs"]
[null,null,null,null,"Coffee",{"$f":"C18+C17","v":0.35}]
[null,null,null,null,"Donut",{"$f":"C11","v":0.5}]
[null,null,null,null,"Total variable cost ",{"$f":"SUM(F5:F6)","v":0.85}]
[null,"Time period"]
["Revenue: Cup of Coffee",null,4]
["Revenue: Donut",null,3.5,null,"Month","No of units ",null,null,"Unit price ","Sales",null,null,"Unit cost ","Total cost",null,null,"Profit"]
["Donut ingredients per donunt)","per donut",0.5,null,null,2018,2019,2020,null,2018,2019,2020,null,2018,2019,2020,2018,2019,2020]
["paper products: napkins, plates etc",null,null,null,"Jan ",2302,2403,2695,7.5,{"$f":"F12*I12","v":17265},{"$f":"G12*I12","v":18022.5},{"$f":"H12*I12","v":20212.5},0.85,{"$f":"M12*F12","v":1956.7},{"$f":"M12*G12","v":2042.55},{"$f":"M12*H12","v":2290.75},{"$f":"J12-N12","v":15308.3},{"$f":"K12-O12","v":15979.95},{"$f":"L12-P12","v":17921.75}]
["Insurance","month",200,null,"Feb ",2792.5,2473.5,3203,7.5,20943.75,{"$f":"G13*I13","v":18551.25},{"$f":"H13*I13","v":24022.5},0.85,2373.625,{"$f":"M13*G13","v":2102.4749999999999},{"$f":"M13*H13","v":2722.5499999999997},{"$f":"J13-N13","v":18570.125},{"$f":"K13-O13","v":16448.775000000001},{"$f":"L13-P13","v":21299.95}]
[" ",null,null,null,"Mar",2454.5,2583.5,3056,7.5,18408.75,19376.25,22920,0.85,2086.3249999999998,2195.9749999999999,2597.6,16322.424999999999,17180.275000000001,20322.400000000001]
["Maintenance & Repairs to equipment","month",0,null,"Apr",3254,3362,3620,7.5,24405,25215,27150,0.85,2765.9,2857.7,3077,21639.1,22357.3,24073]
["Marketing & Promotion: Advertising","month",50,null,"May",3586.5,3400.5,3981.5,7.5,26898.75,25503.75,29861.25,0.85,3048.5250000000001,2890.4249999999997,3384.2750000000001,23850.224999999999,22613.325000000001,26476.974999999999]
["Coffee ","per cup",0.25,null,"Jun",2635.5,3628.5,4053.5,7.5,19766.25,27213.75,30401.25,0.85,2240.1749999999997,3084.2249999999999,3445.4749999999999,17526.075000000001,24129.525000000001,26955.775000000001]
["Coffee cups ","per cup",0.1,null,"Jul",1986,2614,3161,7.5,14895,19605,23707.5,0.85,1688.1,2221.9,2686.85,13206.9,17383.099999999999,21020.65]
["Payroll:  Wages (Owner/ Manager)","month",2500,null,"Aug",2685,2979,3619,7.5,20137.5,22342.5,27142.5,0.85,2282.25,2532.15,3076.15,17855.25,19810.349999999999,24066.35]
["Payroll:  Wages (per Employees)","month",1000,null,"Sep",2868,3129,3613,7.5,21510,23467.5,27097.5,0.85,2437.7999999999997,2659.65,3071.0499999999997,19072.2,20807.849999999999,24026.45]
["Donut and Coffee equipment rent ","month",500,null,"Oct",2948,3912,4048,7.5,22110,29340,30360,0.85,2505.7999999999997,3325.2,3440.7999999999997,19604.2,26014.799999999999,26919.200000000001]
["Professional Fees: Accounting","month",50,null,"Nov",3451.5,4162.5,4529,7.5,25886.25,31218.75,33967.5,0.85,2933.7750000000001,3538.125,3849.65,22952.474999999999,27680.625,30117.85]
["Professional Fees: Legal","month",25,null,"Dec",4523.5,4958.5,5788,7.5,33926.25,37188.75,43410,0.85,3844.9749999999999,4214.7249999999995,4919.8,30081.275000000001,32974.025000000001,38490.199999999997]
["Powdered and Liquid Beverages",null,0,null,"TOTAL",{"$f":"SUM(F12:F23)","v":35487},{"$f":"SUM(G12:G23)","v":39606},{"$f":"SUM(H12:H23)","v":45367},null,{"$f":"SUM(J12:J23)","v":266152.5},{"$f":"SUM(K12:K23)","v":297045},{"$f":"SUM(L12:L23)","v":340252.5},null,{"$f":"SUM(N12:N23)","v":30163.949999999997},{"$f":"SUM(O12:O23)","v":33665.100000000006},{"$f":"SUM(P12:P23)","v":38561.949999999997},{"$f":"SUM(Q12:Q23)","v":235988.55000000005},263379.90000000002,301690.55]
["Rent","month",1000]
["Previous research expense for Donuts advancements",null,1500," "]
["Supplies: Office","month",25]
["Utilities","month",200]
[null,null,null,null,"Profit"]
[]
[]
[null,null,null,null,"Total Profit"]
[]
["Additional Data"]
["Monthly Production","Lost Sales","Day old revenue","High demand, % above Average","Low Demand, % below average"]
[4000,3,1.25,0.22,0.26]
["Franchise "]
["Monthly Fixed Expense increase",7000]
["Monthly Production Increase",0.32]
["Monthly demand increase",0.24]
["States of Natures ","probabilities "]
["High demand",0.2]
["Average demand",0.55000000000000004]
["Low demand",0.25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total "]

{"sheet":"SI and regression Pt 1","index":3,"n_rows":102,"n_cols":26,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
["Month","Demand","Yearly average","Seasonal Index","Average SI","Deseasonalized","Time period",null,null,"Regression Output"]
["2018-01-01",2302,null,{"$f":"B2/C13","v":0.77842590244314824},{"$f":"3209/3070","v":1.0452768729641695},{"$f":"24067.5/E2","v":23024.999999999996},"2018-01-01",null,"CLICK CELL J2 as output cell for regression","SUMMARY OUTPUT"]
["2018-02-01",2792.5,null,{"$f":"B3/C13","v":0.94428945811142107},{"$f":"2778/3070","v":0.90488599348534204},{"$f":"20835/E3","v":23025},"2018-02-01"]
["2018-03-01",2454.5,null,{"$f":"B4/C13","v":0.82999408234001182},{"$f":"2428/3070","v":0.79087947882736154},{"$f":"18210/E4","v":23025},"2018-03-01",null,null,"Regression Statistics"]
["2018-04-01",3254,null,{"$f":"B5/C13","v":1.1003466057993068},{"$f":"3209/3070","v":1.0452768729641695},{"$f":"24067.5/E5","v":23024.999999999996},"2018-04-01",null,null,"Multiple R",0.93693522036494714]
["2018-05-01",3586.5,null,{"$f":"B6/C13","v":1.2127821455744356},{"$f":"2778/3070","v":0.90488599348534204},{"$f":"20835/E6","v":23025},"2018-05-01",null,null,"R Square",0.87784760716031196]
["2018-06-01",2635.5,null,{"$f":"B7/C13","v":0.89119959421760087},{"$f":"2428/3070","v":0.79087947882736154},{"$f":"18210/E7","v":23025},"2018-06-01",null,null,"Adjusted R Square",0.87021308260783148]
["2018-07-01",1986,null,{"$f":"B8/C13","v":0.67156987065686025},{"$f":"3209/3070","v":1.0452768729641695},{"$f":"24067.5/E8","v":23024.999999999996},"2018-07-01",null,null,"Standard Error",112.3013084566544]
["2018-08-01",2685,null,{"$f":"B9/C13","v":0.90793811818412373},{"$f":"2778/3070","v":0.90488599348534204},{"$f":"20835/E9","v":23025},"2018-08-01",null,null,"Observations",35]
["2018-09-01",2868,null,{"$f":"B10/C13","v":0.96981993406036016},{"$f":"2428/3070","v":0.79087947882736154},{"$f":"18210/E10","v":23025},"2018-09-01"]
["2018-10-01",2948,null,{"$f":"B11/C13","v":0.99687209400625576},{"$f":"3209/3070","v":1.0452768729641695},{"$f":"24067.5/E11","v":23024.999999999996},"2018-10-01",null,null,"ANOVA"]
["2018-11-01",3451.5,"Put yearly average in below cell ",{"$f":"B12/13","v":265.5},{"$f":"2778/3070","v":0.90488599348534204},{"$f":"20835/E12","v":23025},"2018-11-01",null,null,null,"df","SS","MS","F","Significance F"]
["2018-12-01",4523.5,{"$f":"AVERAGE(B2:B13)","v":2957.25},{"$f":"B13/C13","v":1.5296305689407388},{"$f":"2428/3070","v":0.79087947882736154},{"$f":"18210/E13","v":23025},"2018-12-01",null,null,"Regression",2,2900258.85866269,1450129.429331345,114.98392612740955,2.4571499493063338E-15]
["2019-01-01",2403,null,{"$f":"B14/C25","v":0.72807150431752765},{"$f":"2217/3436.5","v":0.64513312963771274},{"$f":"16627.5/E14","v":25773.750000000004},"2019-01-01",null,null,"Residual",32,403570.68419445236,12611.583881076636]
["2019-02-01",2473.5,null,{"$f":"B15/C25","v":0.74943190425693074},{"$f":"2683.5/3436.5","v":0.78088171104321258},{"$f":"20126.25/E15","v":25773.75},"2019-02-01",null,null,"Total",34,3303829.5428571422]
["2019-03-01",2583.5,null,{"$f":"B16/C25","v":0.78276018785032575},{"$f":"2217/3436.5","v":0.64513312963771274},{"$f":"16627.5/E16","v":25773.750000000004},"2019-03-01"]
["2019-04-01",3362,null,{"$f":"B17/C25","v":1.0186335403726707},{"$f":"2683.5/3436.5","v":0.78088171104321258},{"$f":"20126.25/E17","v":25773.75},"2019-04-01",null,null,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%","Lower 95.0%","Upper 95.0%"]
["2019-05-01",3400.5,null,{"$f":"B18/C25","v":1.0302984396303589},{"$f":"2217/3436.5","v":0.64513312963771274},{"$f":"16627.5/E18","v":25773.750000000004},"2019-05-01",null,null,"Intercept",38719.298001925585,406.69861252805788,95.203909748411945,7.7205815665601444E-41,37890.880041010096,39547.715962841074,37890.880041010096,39547.715962841074]
["2019-06-01",3628.5,null,{"$f":"B19/C25","v":1.0993788819875776},{"$f":"2683.5/3436.5","v":0.78088171104321258},{"$f":"20126.25/E19","v":25773.75},"2019-06-01",null,null,1.0452768729641695,330.15507742651624,198.29080527465118,1.6650044714338661,0.10567445453349311,-73.750073743834676,734.0602285968672,-73.750073743834676,734.0602285968672]
["2019-07-01",2614,null,{"$f":"B20/C25","v":0.79200121193758521},{"$f":"2217/3436.5","v":0.64513312963771274},{"$f":"16627.5/E20","v":25773.750000000004},"2019-07-01",null,null,23024.999999999996,0.16875523281494545,1.2015174639253848E-2,14.045175195674499,3.1153246938926202E-15,0.14428112307352728,0.19322934255636362,0.14428112307352728,0.19322934255636362]
["2019-08-01",2979,null,{"$f":"B21/C25","v":0.90259051658839573},{"$f":"2683.5/3436.5","v":0.78088171104321258},{"$f":"20126.25/E21","v":25773.75},"2019-08-01"]
["2019-09-01",3129,null,{"$f":"B22/C25","v":0.94803817603393425},{"$f":"2217/3436.5","v":0.64513312963771274},{"$f":"16627.5/E22","v":25773.750000000004},"2019-09-01"]
["2019-10-01",3912,null,{"$f":"B23/C25","v":1.1852749583396456},{"$f":"2683.5/3436.5","v":0.78088171104321258},{"$f":"20126.25/E23","v":25773.75},"2019-10-01"]
["2019-11-01",4162.5,"Put yearly average in below cell ",{"$f":"B24/C25","v":1.261172549613695},{"$f":"2217/3436.5","v":0.64513312963771274},{"$f":"16627.5/E24","v":25773.750000000004},"2019-11-01"]
["2019-12-01",4958.5,{"$f":"AVERAGE(B14:B25)","v":3300.5},{"$f":"B25/C25","v":1.5023481290713527},{"$f":"2683.5/3436.5","v":0.78088171104321258},{"$f":"20126.25/E25","v":25773.75},"2019-12-01"]
["2020-01-01",2695,null,{"$f":"B26/C37","v":0.71285295479092725},{"$f":"2674/3657.5","v":0.73110047846889947},{"$f":"20055/E26","v":27431.250000000004},"2020-01-01"]
["2020-02-01",3203,null,{"$f":"B27/C37","v":0.8472237529481782},{"$f":"3112.5/3657.5","v":0.85099111414900885},{"$f":"23343.75/E27","v":27431.25},"2020-02-01"]
["2020-03-01",3056,null,{"$f":"B28/C37","v":0.80834086450503662},{"$f":"2674/3657.5","v":0.73110047846889947},{"$f":"20055/E28","v":27431.250000000004},"2020-03-01"]
["2020-04-01",3620,null,{"$f":"B29/C37","v":0.95752419159300806},{"$f":"3112.5/3657.5","v":0.85099111414900885},{"$f":"23343.75/E29","v":27431.25},"2020-04-01"]
["2020-05-01",3981.5,null,{"$f":"B30/C37","v":1.0531443560297131},{"$f":"2674/3657.5","v":0.73110047846889947},{"$f":"20055/E30","v":27431.250000000004},"2020-05-01"]
["2020-06-01",4053.5,null,{"$f":"B31/C37","v":1.0721890360834967},{"$f":"3112.5/3657.5","v":0.85099111414900885},{"$f":"23343.75/E31","v":27431.25},"2020-06-01"]
["2020-07-01",3161,null,{"$f":"B32/C37","v":0.83611435625013775},{"$f":"2674/3657.5","v":0.73110047846889947},{"$f":"20055/E32","v":27431.250000000004},"2020-07-01"]
["2020-08-01",3619,null,{"$f":"B33/C37","v":0.95725968214781665},{"$f":"3112.5/3657.5","v":0.85099111414900885},{"$f":"23343.75/E33","v":27431.25},"2020-08-01"]
["2020-09-01",3613,null,{"$f":"B34/C37","v":0.95567262547666798},{"$f":"2674/3657.5","v":0.73110047846889947},{"$f":"20055/E34","v":27431.250000000004},"2020-09-01"]
["2020-10-01",4048,null,{"$f":"B35/C37","v":1.070734234134944},{"$f":"3112.5/3657.5","v":0.85099111414900885},{"$f":"23343.75/E35","v":27431.25},"2020-10-01"]
["2020-11-01",4529,"Put yearly average in below cell ",{"$f":"B36/C37","v":1.1979632772720259},{"$f":"2674/3657.5","v":0.73110047846889947},{"$f":"20055/E36","v":27431.250000000004},"2020-11-01",null,"Use the average seasonal Index  in the column for year 2018"]
["2020-12-01",5788,{"$f":"AVERAGE(B26:B37)","v":3780.5833333333335},{"$f":"B37/C37","v":1.5309806687680472},{"$f":"3112.5/3657.5","v":0.85099111414900885},{"$f":"23343.75/E37","v":27431.25},"2020-12-01","Deseasonalized forecast","Seasonalized forecast"]
[null,null,null,null,null,null,null,{"$f":"F2","v":23024.999999999996},{"$f":"D2","v":0.77842590244314824},"When you move your forecast to the profit models, you must use an equation, not just copy the values"]
[null,null,null,null,null,null,null,{"$f":"F3","v":23025},{"$f":"D3","v":0.94428945811142107}]
[null,null,null,null,null,null,null,23025,{"$f":"D4","v":0.82999408234001182}]
[null,null,null,null,null,null,null,23024.999999999996,{"$f":"D5","v":1.1003466057993068}]
[null,null,null,null,null,null,null,23025,{"$f":"D6","v":1.2127821455744356}]
[null,null,null,null,null,null,null,23025,{"$f":"D7","v":0.89119959421760087}]
[null,null,null,null,null,null,null,23024.999999999996,{"$f":"D8","v":0.67156987065686025}]
[null,null,null,null,null,null,null,23025,{"$f":"D9","v":0.90793811818412373}]
[null,null,null,null,null,null,null,23025,{"$f":"D10","v":0.96981993406036016}]
[null,null,null,null,null,null,null,23024.999999999996,{"$f":"D11","v":0.99687209400625576}]
[null,null,null,null,null,null,null,23025,{"$f":"D12","v":265.5}]
[null,null,null,null,null,null,null,23025,{"$f":"D13","v":1.5296305689407388}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Melissa Salgado"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]

{"sheet":"Current operations Pt2 & Pt3 ","index":4,"n_rows":201,"n_cols":26,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
["CURRENT OPERATIONS",null,null,null,"Monthly Production","Lost Sales","Day old revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"test"]
["Part 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer 2020 "]
["AVERAGE DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3","You should be able to copy from average to high and low and then just make some modifications"]
["HIGH DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3"]
["LOW DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Melissa Salgado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]

{"sheet":"Franchise operations Pt2 & Pt3","index":5,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["FRANCHISE",null,null,null,"Monthly Production","Lost Sales","Day old revenue"]
["Part 2"]
["AVERAGE DEMAND"]
["Month "]
["Demand",null,null,null,null,null,null,null,null,null,null,null," "]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3"]
["HIGH DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3"]
["LOW DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]

{"sheet":"Expected Values Pt3","index":6,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[[46,2,46,4],[54,2,54,4],[2,2,2,4],[10,2,10,4],[17,2,17,4],[24,2,24,4],[31,2,31,4],[38,2,38,4]]}
[null,"PAYOFF TABLE"]
[]
[null,null,"State of Nature",null,null,null,null,"Summary of Results ","Methods "]
[null,"Decision Alternatives","Low ","Average ","High ",null,null,{"$f":"B4","v":"Decision Alternatives"},"Maximin","MaxiMax","Laplace ","MinMax regret","EVUII","EOL"]
[]
[]
[null,null,null,null,null,null,null,"Decision Alternatives"]
[null,"DM UNDER IGNORANCE"]
[null,null,null,null,null,null,null,"Kiana should choose to:"]
[null,"Maximin"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ",null,null,"Because:"]
[]
[]
[]
[]
[null,"Maximax"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[]
[]
[]
[null,"Laplace"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[]
[]
[]
[null,"Minimax Regret"]
[null,"Regret table","State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[]
[]
[null,"DM UNDER RISK"]
[null,"EVUII"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]
[]
[]
[]
[]
[null,"EVUPI"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]
[]
[]
[null,"EVPI"]
[]
[null,"EOL"]
[null,"Regret table","State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]

{"sheet":"Sheet9","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}